<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="org.vsg.stock.basic.domain.mybatis.VolFigureDetailsProxy">


	<resultMap id="VolFigureDetailResult" type="org.vsg.stock.basic.domain.mybatis.VolFigureDetailsProxy">
		<id property="code" column="CODE" />
		<result property="volFigureCode" column="VOL_FIGURE_CODE"/>
		<result property="desc" column="description"/>
		<result property="procClassName" column="PROC_CLASS_NAME"/>
		<result property="disabled" column="flag_disabled"/>
	</resultMap>

	<select id="findByFigureCode"  resultMap="VolFigureDetailResult" parameterType="String">
    	select 
    	  VOL_FIGURE_CODE , CODE, description , PROC_CLASS_NAME ,flag_disabled from VOL_FIGURE_DETAILS 
    	where  VOL_FIGURE_CODE = #{volFigureCode}
  	</select>
  	
	<select id="findAll"  resultMap="VolFigureDetailResult">
    	select 
    	  VOL_FIGURE_CODE , CODE, description , PROC_CLASS_NAME ,flag_disabled from VOL_FIGURE_DETAILS 
  	</select>
  	
  		

</mapper>
